Gestor 41T1Ak1KcqlrCDGA4njsr9XEjYzZTyLda1r9zPtM4AfHEsHNTUvTccNDbczqAC1O5Nb171hR+vXqbdH44SXnRsJeZQ1IQJKMfBWlaHT4LF7EWvkJ1UqapMBu6IXlKetj38j1AtML8rx5ey0c Gestor config nome_fantasia,System.String cnpj_cpf,System.String logradouro,System.String numero,System.String bairro,System.String uf,System.String telefone,System.String razao_social,System.String cidade,System.String ie_rg,System.String 30 False config Gestor select c.razao_social, c.nome_fantasia, c.cnpj_cpf, c.logradouro, c.numero, c.bairro, c.uf, c.telefone, cidade.nome as cidade, c.ie_rg from configuracao c left join cidade on cidade.id = c.cidade_id dados produto_id,System.Int32 descricao,System.String quantidade,System.Decimal custo,System.Decimal valor_liquido,System.Decimal data_emissao,System.DateTime diferenca,System.Decimal percentage,System.Decimal 30 False dados Gestor select orc_item.produto_id, orc_item.descricao, orc_item.quantidade, (orc_item.quantidade * p.valor_custo) AS custo, orc_item.valor_liquido, orc.data_emissao, (orc_item.valor_liquido - (orc_item.quantidade * p.valor_custo)) as diferenca, ((orc_item.valor_liquido - (orc_item.quantidade * p.valor_custo)) / (orc_item.quantidade * p.valor_custo) * 100) as percentage From orcamento_item orc_item left join produto p on p.id = orc_item.produto_id left join orcamento orc on orc.id = orc_item.orcamento_id where DATE_FORMAT(CAST(orc.data_emissao as DATE), '%Y-%m-%d') between DATE_FORMAT(STR_TO_DATE('{Data.FromDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND DATE_FORMAT(STR_TO_DATE('{Data.ToDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') produto produtos,System.String id_produto,System.Int32 30 False produto Gestor select DISTINCT(p.descricao) as produtos, p.id as id_produto from orcamento orc inner join orcamento_item orc_item on orc_item.orcamento_id = orc.id inner join produto p on p.id = orc_item.produto_id inner join unidade un on un.id = p.unidade_id where orc.status = 'Faturado' order by p.descricao ,versao,versao,Versão_x0020_do_x0020_Sistema,System.String,,False,False,False ,descricao_filtros,descricao_filtros,System.String,,False,False ,codigo_relatorio,codigo_relatorio,System.String,,False,False ,cliente_id,cliente_id,System.Int32,_x0030_,False,False ,data_inicial,data_inicial,System.String,,False,False ,data_final,data_final,System.String,,False,False ,Data,Data,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x005F_x0031_1_x005F_x002F_19_x005F_x002F_2018_x005F_x0020_3:57:18_x005F_x0020_PM_x002C__x005F_x0031_1_x005F_x002F_19_x005F_x002F_2018_x005F_x0020_3:57:18_x005F_x0020_PM,False,False ,Produto,Produto,System.String,,False,False EngineV2 // Se existir imagem de logo string arquivoLogo = System.IO.Path.Combine(Application.StartupPath, "Relatorios", "logo_empresa.png"); if (System.IO.File.Exists(arquivoLogo)) { imgLogo.Image = System.Drawing.Image.FromFile(arquivoLogo); } dbNaoEncontrado.Enabled = Totals.Count(DataBand1) == 0; None;Black;2;Solid;False;4;Black Transparent Transparent 0,26.9,19,0.8 Transparent 15.4,0.1,3.6,0.4 Arial,10 Right 0,0,0,0 Text3 {PageNofMThrough} Black Transparent 0,0.1,8.4,0.6 Arial,8 0,0,0,0 Text21 Kinyx Gestor v.{versao} - www.kinyx.com.br Black Expression PageFooterBand1 Transparent 0,0.4,19,3.6 GlassBrush,Gainsboro,True,0.2 0,2.2,19,0.8 Transparent 0.2,0.1,18.6,0.6 Tahoma,14.25,Bold,Point,False,0 32fcfe6cb44346faa56d0ab4459ef577 Center 0,0,0,0 Text1 LUCRO PERÍODO Black Expression 4c6a4053e22b45a08cd86e38ff590dc3 Panel1 Transparent 2.2,0,13.6,0.6 Tahoma,9.75,Bold,Point,False,0 2701cf8d53154cbc83df5c54d5e56e36 0,0,0,0 Text4 {config.razao_social} Black Expression Transparent 2.2,0.4,13.6,1.8 Tahoma,9,Regular,Point,False,0 153d69fa8067494d9cdea54640126859 0,0,0,0 Text14 CNPJ: {config.cnpj_cpf} - IE: {config.ie_rg} End.: {config.logradouro}, {config.numero} Bairro: {config.bairro} {config.cidade}/{config.uf} Black Expression Transparent 13.6,0.2,5.4,0.6 Tahoma,8.25,Bold,Point,False,0 47116c593046488ca547f97e20ef2bcf Right 0,0,0,0 Text2 {Today.ToString("dd/MM/yyyy")} {Time.ToString("HH:mm")} Black Expression Transparent 15.8,0.6,3.2,0.6 Tahoma,8.25,Bold,Point,False,0 3bfa00ed32e643b7b393ced7fd1432a3 Right 0,0,0,0 Text11 Rel: {codigo_relatorio} Black Expression Transparent 0,0,2.2,2.2 c44815fb27a84ee5b1e37e997d4616bb imgLogo Transparent 0,3,19,0.6 Tahoma,8.25,Bold,Point,False,0 a1df6857f70d4ebe85448eabedceaf40 0,0,0,0 Text44 {descricao_filtros} Black Expression Center ReportTitleBand1 Transparent 0,4.8,19,0.4 Transparent 1.2,0,8.8,0.4 Arial,6.75,Bold,Point,False,0 6878e571f7984459b1c145c2d0881f2d 0,0,0,0 Text24 Descrição Black Expression Transparent 0,0,1.2,0.4 Arial,6.75,Bold,Point,False,0 cf7562448bdd48609fba3fae19e1193e 0,0,0,0 Text23 Código Black Expression Transparent 10,0,1.4,0.4 Arial,6.75,Bold,Point,False,0 ebc2a6a26d2c437fa2ec0d6437a63d59 Right 0,0,0,0 Text26 Quantidade Black Expression Transparent 11.4,0,2,0.4 Arial,6.75,Bold,Point,False,0 a3e909581f254bfb9c44e06d6348e204 Right 0,0,0,0 Text25 Custo Black Expression Transparent 13.4,0,2,0.4 Arial,6.75,Bold,Point,False,0 60028ae96c2a45d797bab64b66fa7a3d Right 0,0,0,0 Text27 Venda Black Expression Transparent 15.4,0,1.8,0.4 Arial,6.75,Bold,Point,False,0 e6f9535a1efb45778ed6dd568ed94c73 Right 0,0,0,0 Text28 Diferença Black Expression Transparent 17.2,0,1.8,0.4 Arial,6.75,Bold,Point,False,0 62cafe1950a1445ebe8c785e98154461 Right 0,0,0,0 Text12 Markup Black Expression 0,0,0,0 StartPointPrimitive2 962dfd4de817421cac0292f111677af1 19,0.4,0,0 EndPointPrimitive2 962dfd4de817421cac0292f111677af1 GroupHeaderBand1 Transparent 0,6,19,0.4 Transparent 0,0,1.2,0.4 Arial,6.75,Regular,Point,False,0 f702cd353aeb4151a7d64fef79cb37e7 0,0,0,0 Text5 {dados.produto_id} Black 000000 Expression Transparent 13.4,0,2,0.4 Arial,6.75,Regular,Point,False,0 1b313afd5cc649a3a66e163d9389db25 Right 0,0,0,0 Text13 {dados.valor_liquido} Black , . 9 2 R$ Expression Transparent 10,0,1.4,0.4 Arial,6.75,Regular,Point,False,0 4d814cbbbf53419781620955e169889c Right 0,0,0,0 Text15 {dados.quantidade} Black , . 1 Expression Transparent 11.4,0,2,0.4 Arial,6.75,Regular,Point,False,0 9a25747a07cb43f69b4440d40ed9b219 Right 0,0,0,0 Text16 {dados.custo} Black , . 9 2 R$ Expression Transparent 15.4,0,1.8,0.4 Arial,6.75,Regular,Point,False,0 322220255201435cb0cdcfebf4c6b900 Right 0,0,0,0 Text6 {dados.diferenca} Black , . 9 2 R$ DataColumn Transparent 1.2,0,8.8,0.4 Arial,6.75,Regular,Point,False,0 a5289d521ddf43d7892311223178fd98 0,0,0,0 Text10 {dados.descricao} Black Expression Transparent 17.2,0,1.8,0.4 Arial,6.75,Regular,Point,False,0 831baf0827424cb4897e1a2817bf6880 Right 0,0,0,0 Text7 {dados.percentage} Black , . 1 DataColumn 0,0.4,19,0.0254 Black Black HorizontalLinePrimitive1 Black dados DataBand1 ASC codigo Transparent 0,7.2,19,0.8 Transparent 8.6,0,1.4,0.4 Arial,6.75,Bold,Point,False,0 2763baae78074cedb1f2862fe8aa6803 Right 0,0,0,0 Text8 Totais Black Expression Transparent 10,0,1.4,0.4 Arial,6.75,Regular,Point,False,0 a3ddcf4a7fe545fc9c3c1a75cf1909f2 Right 0,0,0,0 Text17 {Sum(DataBand1,dados.quantidade)} Black , . 1 Totals Transparent 11.4,0,2,0.4 Arial,6.75,Regular,Point,False,0 ef5a1b3c49c4417aa65d5fb52e7bd93d Right 0,0,0,0 Text18 {Sum(DataBand1,dados.custo)} Black , . 9 2 R$ Totals Transparent 13.4,0,2,0.4 Arial,6.75,Regular,Point,False,0 94b8652ac8654aca9fe498a3575ce6ae Right 0,0,0,0 Text19 {Sum(DataBand1,dados.valor_liquido)} Black , . 9 2 R$ Totals Transparent 15.4,0,1.8,0.4 Arial,6.75,Regular,Point,False,0 64b3a8def3ba43c9a25e518aa3609133 Right 0,0,0,0 Text20 {Sum(DataBand1,dados.diferenca)} Black , . 9 2 R$ Totals Transparent 17.2,0,1.8,0.4 Arial,6.75,Regular,Point,False,0 dbb93b85d6994f7caeffd6c6adf108fc Right 0,0,0,0 Text22 {Sum(DataBand1,dados.percentage)} Black , . 1 Totals GroupFooterBand2 Transparent 0,8.8,19,1.8 Transparent 0.2,0,1.2,1.6 Arial,36,Regular,Point,False,0 0f4dff5fc8484990a26a72f3e0be2875 0,0,0,0 Text9 :( Black Expression Transparent 1.4,0.4,17.6,1 Calibri,20.25,Regular,Point,False,0 80e663d7c3af4281aca045a0c2fdc795 0,0,0,0 Text29 Nenhum registro encontrado com os parâmetros informados. Black Expression dbNaoEncontrado 0,4.8,19,0.4 Black 962dfd4de817421cac0292f111677af1 RectanglePrimitive2 16e140f4ea7b4950b32fdf7a12ea7df3 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] Control Window 32,40,96,20 Microsoft Sans Serif,8 Black Short 85e9fec4649d4d7da5ea14473e299dde 32, 40 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM dtInicial 96, 20 2/6/2018 4:30:02 PM Window 168,40,96,20 Microsoft Sans Serif,8 Black Short 08dcfee395e446a783d35ac56d1059c6 168, 40 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM dtFinal 96, 20 2/6/2018 4:30:08 PM Control 32,16,96,24 Microsoft Sans Serif,8 Black 29219039acfc4f938a4406d9b5c65853 32, 16 LabelControl1 96, 24 Data Inicial Control 168,16,96,24 Microsoft Sans Serif,8 Black 56a311c019e946b3b14d443c5547188c 168, 16 LabelControl2 96, 24 Data Final 32,96,96,24 Cancel Microsoft Sans Serif,8 Black a903c72c292f4c039a118c23a8e52122 32, 96 btnCancelar 96, 24 Cancelar Data.From = dtInicial.Value; Data.To = dtFinal.Value; 168,96,96,24 OK Microsoft Sans Serif,8 Black 74a4e67974e04e24901c28ddee531f75 168, 96 btnGerar 96, 24 Gerar Microsoft Sans Serif,8 4b284ec95a1747aaa2a0c18056bcb5cf 0, 0 periodo 304, 160 Selecione o Período System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Report 6/27/2019 10:26:31 AM 9/25/2015 9:37:43 PM D:\Kinyx\Relatórios\LUCRO PERIODO.mrt af022aeea8b34212bbb051158217de1c Report Centimeters 2015.1.0 CSharp